select * from `frame` 
where `start_node_id` = 'N2'
or `end_node_id` = 'N2'


select * from `frame` 
where `frame_name` = 'column'

select * from `frame` 
where `frame_name` = 'column'
or `material_id_material` = 'M2'


select * from `frame` 
where `frame_name` = 'column'
and `material_id_material` = 'M2'


select * from `frame` 
where `frame_name` = 'column'
and `material_id_material` = 'M3'


select * from `frame` 
where `frame_name` = 'column'
and `section_id_section` = 'S3'


select * from `material` 
inner join `concrete` ON `material`.`material_type` = `concrete`.`id_concrete`
where `material_type`='C20/25'


select * from `material` 
inner join `concrete` ON `material`.`material_type` = `concrete`.`id_concrete`
where `material_type`='C30/37'


select * from `material` 
inner join `concrete` ON `material`.`material_type` = `concrete`.`id_concrete`


select * from `material` 
inner join `wood` ON `material`.`material_type` = `wood`.`id_wood`


select * from `frame` 
inner join `section` ON `frame`.`section_id_section` = `section`.`id_section`


select * from `frame` 
inner join `section` ON `frame`.`section_id_section` = `section`.`id_section`
inner join `material` ON `frame`.`material_id_material` = `material`.`id_material`
order by `frame`.`id_frame`



select * from `frame` 
inner join `section` ON `frame`.`section_id_section` = `section`.`id_section`
inner join `material` ON `frame`.`material_id_material` = `material`.`id_material`
where `section`.`id_section`='S1' or `material`.`id_material`='M1'
order by `frame`.`id_frame`

select * from `frame` 
inner join `section` ON `frame`.`section_id_section` = `section`.`id_section`
inner join `material` ON `frame`.`material_id_material` = `material`.`id_material`
where `section`.`id_section`='S1' and `material`.`id_material`='M1'
order by `frame`.`id_frame`

> Essayez S2 avec M2, et S3 avec M3


Commande de la présentation ppt "MySQL - Assemblage des tables pour le portique":

select `id_frame`,`frame_name`,`start_node_id`,`end_node_id`,`id_section`,`section_name`,`section_type`,`id_material`,`material_name`,`material_type`
from `frame`
inner join `section` ON `frame`.`section_id_section` = `section`.`id_section`
inner join `material` ON `frame`.`material_id_material` = `material`.`id_material`
order by `frame`.`id_frame`